IF EXISTS (SELECT * FROM SYSOBJECTS WHERE name = 'Professors' AND xtype = 'U')
BEGIN
	DROP TABLE Professors
END
ELSE
	BEGIN
		CREATE TABLE  Professors
		(
			ProfessorId		int not null IDENTITY(1,1),
			Nome		varchar(250) not null,
			Rg				varchar(20),
			Cpf				varchar(20),
			Inscricao		varchar(100)
		)
	END
GO

IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE name = 'pk_ProfessorsId' AND xtype = 'PK')
BEGIN
	ALTER TABLE Professors
	ADD CONSTRAINT pk_ProfessorsId PRIMARY KEY ([ProfessorId])
END
GO

